Overview

Dataset statistics

Number of variables36
Number of observations887379
Missing cells3125093
Missing cells (%)9.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory243.7 MiB
Average record size in memory288.0 B

Variable types

NUM22
CAT13
UNSUPPORTED1

Warnings

batch_ID has a high cardinality: 207 distinct values High cardinality
State has a high cardinality: 51 distinct values High cardinality
last_week_pay has a high cardinality: 98 distinct values High cardinality
sub_grade is highly correlated with gradeHigh correlation
grade is highly correlated with sub_gradeHigh correlation
batch_ID has 130748 (14.7%) missing values Missing
Emp_designation has 51463 (5.8%) missing values Missing
Experience has 44825 (5.1%) missing values Missing
mths_since_last_delinq has 454312 (51.2%) missing values Missing
mths_since_last_record has 750326 (84.6%) missing values Missing
mths_since_last_major_derog has 665676 (75.0%) missing values Missing
verification_status_joint has 886868 (99.9%) missing values Missing
tot_colle_amt has 70276 (7.9%) missing values Missing
tot_curr_bal has 70276 (7.9%) missing values Missing
annual_inc is highly skewed (γ1 = 44.47848687) Skewed
debt_income_ratio is highly skewed (γ1 = 441.4867751) Skewed
collection_recovery_fee is highly skewed (γ1 = 29.65569253) Skewed
acc_now_delinq is highly skewed (γ1 = 24.06635681) Skewed
tot_colle_amt is highly skewed (γ1 = 856.1805436) Skewed
member_id has unique values Unique
Emp_designation is an unsupported type, check if it needs cleaning or further analysis Unsupported
delinq_2yrs has 716961 (80.8%) zeros Zeros
inq_last_6mths has 497905 (56.1%) zeros Zeros
pub_rec has 751572 (84.7%) zeros Zeros
total_rec_int has 18214 (2.1%) zeros Zeros
total_rec_late_fee has 874862 (98.6%) zeros Zeros
recoveries has 862702 (97.2%) zeros Zeros
collection_recovery_fee has 863872 (97.4%) zeros Zeros
collections_12_mths_ex_med has 875553 (98.7%) zeros Zeros
acc_now_delinq has 883236 (99.5%) zeros Zeros
tot_colle_amt has 700946 (79.0%) zeros Zeros

Reproduction

Analysis started2020-09-23 15:44:03.407221
Analysis finished2020-09-23 15:50:37.819796
Duration6 minutes and 34.41 seconds
Software versionpandas-profiling v2.9.0
Download configurationconfig.yaml

Variables

member_id
Real number (ℝ≥0)

UNIQUE

Distinct887379
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35001824.82
Minimum70473
Maximum73544841
Zeros0
Zeros (%)0.0%
Memory size6.8 MiB

Quantile statistics

Minimum70473
5-th percentile1317185.3
Q110877133.5
median37095283
Q358471347
95-th percentile70387497.7
Maximum73544841
Range73474368
Interquartile range (IQR)47594213.5

Descriptive statistics

Standard deviation24113354.68
Coefficient of variation (CV)0.6889170723
Kurtosis-1.465814498
Mean35001824.82
Median Absolute Deviation (MAD)23481873
Skewness0.01741211777
Sum3.10598843e+13
Variance5.814538737e+14
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
587325381< 0.1%
 
96069201< 0.1%
 
11876091< 0.1%
 
347625191< 0.1%
 
704181971< 0.1%
 
698703191< 0.1%
 
137868971< 0.1%
 
116876961< 0.1%
 
557504151< 0.1%
 
610475711< 0.1%
 
Other values (887369)887369> 99.9%
 
ValueCountFrequency (%) 
704731< 0.1%
 
706261< 0.1%
 
706511< 0.1%
 
706811< 0.1%
 
706941< 0.1%
 
ValueCountFrequency (%) 
735448411< 0.1%
 
735448271< 0.1%
 
735428311< 0.1%
 
735198941< 0.1%
 
735198701< 0.1%
 

loan_amnt
Real number (ℝ≥0)

Distinct1372
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14755.26461
Minimum500
Maximum35000
Zeros0
Zeros (%)0.0%
Memory size6.8 MiB

Quantile statistics

Minimum500
5-th percentile3600
Q18000
median13000
Q320000
95-th percentile32000
Maximum35000
Range34500
Interquartile range (IQR)12000

Descriptive statistics

Standard deviation8435.455601
Coefficient of variation (CV)0.5716912456
Kurtosis-0.2567150485
Mean14755.26461
Median Absolute Deviation (MAD)5800
Skewness0.6816831449
Sum1.309351195e+10
Variance71156911.2
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
10000618377.0%
 
12000501835.7%
 
15000472105.3%
 
20000469325.3%
 
35000363684.1%
 
8000278703.1%
 
5000271673.1%
 
6000262073.0%
 
25000241252.7%
 
16000237082.7%
 
Other values (1362)51577258.1%
 
ValueCountFrequency (%) 
50011< 0.1%
 
5501< 0.1%
 
6006< 0.1%
 
7003< 0.1%
 
7251< 0.1%
 
ValueCountFrequency (%) 
35000363684.1%
 
3497531< 0.1%
 
3495018< 0.1%
 
349259< 0.1%
 
3490014< 0.1%
 

terms
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.8 MiB
36 months
621125 
60 months
266254 
ValueCountFrequency (%) 
36 months62112570.0%
 
60 months26625430.0%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length9
Median length9
Mean length9
Min length9

batch_ID
Categorical

HIGH CARDINALITY
MISSING

Distinct207
Distinct (%)< 0.1%
Missing130748
Missing (%)14.7%
Memory size6.8 MiB
234087 
BAT2252229
 
18791
BAT3873588
 
17839
BAT2803411
 
17111
BAT2078974
 
14859
Other values (202)
453944 
ValueCountFrequency (%) 
23408726.4%
 
BAT2252229187912.1%
 
BAT3873588178392.0%
 
BAT2803411171111.9%
 
BAT2078974148591.7%
 
BAT1586599144631.6%
 
BAT1780517139181.6%
 
BAT1104812135051.5%
 
BAT4694572135041.5%
 
BAT1184694122511.4%
 
Other values (197)38630343.5%
 
(Missing)13074814.7%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length10
Median length10
Mean length6.567822768
Min length1

Rate_of_intrst
Real number (ℝ≥0)

Distinct542
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.24673968
Minimum5.32
Maximum28.99
Zeros0
Zeros (%)0.0%
Memory size6.8 MiB

Quantile statistics

Minimum5.32
5-th percentile6.62
Q19.99
median12.99
Q316.2
95-th percentile20.99
Maximum28.99
Range23.67
Interquartile range (IQR)6.21

Descriptive statistics

Standard deviation4.381867415
Coefficient of variation (CV)0.3307883691
Kurtosis-0.1553615492
Mean13.24673968
Median Absolute Deviation (MAD)3
Skewness0.4294806279
Sum11754878.61
Variance19.20076204
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
10.99346243.9%
 
9.17257202.9%
 
15.61252012.8%
 
9.99215532.4%
 
7.89203112.3%
 
13.99190762.1%
 
12.69187832.1%
 
12.29186032.1%
 
12.99185402.1%
 
17.57180012.0%
 
Other values (532)66696775.2%
 
ValueCountFrequency (%) 
5.3296511.1%
 
5.425730.1%
 
5.79410< 0.1%
 
5.9318120.2%
 
5.99347< 0.1%
 
ValueCountFrequency (%) 
28.99112< 0.1%
 
28.49139< 0.1%
 
27.995< 0.1%
 
27.88222< 0.1%
 
27.497< 0.1%
 

grade
Categorical

HIGH CORRELATION

Distinct7
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.8 MiB
B
254535 
C
245860 
A
148202 
D
139542 
E
70705 
Other values (2)
28535 
ValueCountFrequency (%) 
B25453528.7%
 
C24586027.7%
 
A14820216.7%
 
D13954215.7%
 
E707058.0%
 
F230462.6%
 
G54890.6%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length1
Median length1
Mean length1
Min length1

sub_grade
Categorical

HIGH CORRELATION

Distinct35
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.8 MiB
B3
 
56323
B4
 
55626
C1
 
53387
C2
 
52236
C3
 
50161
Other values (30)
619646 
ValueCountFrequency (%) 
B3563236.3%
 
B4556266.3%
 
C1533876.0%
 
C2522365.9%
 
C3501615.7%
 
C4488575.5%
 
B5488335.5%
 
B2487815.5%
 
B1449725.1%
 
A5448165.1%
 
Other values (25)38338743.2%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length2
Median length2
Mean length2
Min length2

Emp_designation
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing51463
Missing (%)5.8%
Memory size6.8 MiB

Experience
Categorical

MISSING

Distinct11
Distinct (%)< 0.1%
Missing44825
Missing (%)5.1%
Memory size6.8 MiB
10+ years
291569 
2 years
78870 
< 1 year
70605 
3 years
70026 
1 year
57095 
Other values (6)
274389 
ValueCountFrequency (%) 
10+ years29156932.9%
 
2 years788708.9%
 
< 1 year706058.0%
 
3 years700267.9%
 
1 year570956.4%
 
5 years557046.3%
 
4 years525295.9%
 
7 years445945.0%
 
8 years439555.0%
 
6 years429504.8%
 
(Missing)448255.1%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length9
Median length7
Mean length7.470315389
Min length3

home_ownership
Categorical

Distinct6
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.8 MiB
MORTGAGE
443557 
RENT
356117 
OWN
87470 
OTHER
 
182
NONE
 
50
ValueCountFrequency (%) 
MORTGAGE44355750.0%
 
RENT35611740.1%
 
OWN874709.9%
 
OTHER182< 0.1%
 
NONE50< 0.1%
 
ANY3< 0.1%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length8
Median length5
Mean length5.901033268
Min length3

annual_inc
Real number (ℝ≥0)

SKEWED

Distinct49384
Distinct (%)5.6%
Missing4
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean75027.58776
Minimum0
Maximum9500000
Zeros2
Zeros (%)< 0.1%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile28000
Q145000
median65000
Q390000
95-th percentile150000
Maximum9500000
Range9500000
Interquartile range (IQR)45000

Descriptive statistics

Standard deviation64698.30014
Coefficient of variation (CV)0.8623268064
Kurtosis4808.192204
Mean75027.58776
Median Absolute Deviation (MAD)20800
Skewness44.47848687
Sum6.657760569e+10
Variance4185870041
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
60000342813.9%
 
50000305753.4%
 
65000254982.9%
 
70000241212.7%
 
40000239432.7%
 
80000227292.6%
 
45000226992.6%
 
75000224352.5%
 
55000207552.3%
 
90000171591.9%
 
Other values (49374)64318072.5%
 
ValueCountFrequency (%) 
02< 0.1%
 
12001< 0.1%
 
17701< 0.1%
 
18961< 0.1%
 
20001< 0.1%
 
ValueCountFrequency (%) 
95000001< 0.1%
 
90000001< 0.1%
 
89000601< 0.1%
 
87065821< 0.1%
 
87000001< 0.1%
 
Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.8 MiB
Source Verified
329558 
Verified
291071 
Not Verified
266750 
ValueCountFrequency (%) 
Source Verified32955837.1%
 
Verified29107132.8%
 
Not Verified26675030.1%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length15
Median length12
Mean length11.8021026
Min length8

purpose
Categorical

Distinct14
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.8 MiB
debt_consolidation
524215 
credit_card
206182 
home_improvement
 
51829
other
 
42894
major_purchase
 
17277
Other values (9)
 
44982
ValueCountFrequency (%) 
debt_consolidation52421559.1%
 
credit_card20618223.2%
 
home_improvement518295.8%
 
other428944.8%
 
major_purchase172771.9%
 
small_business103771.2%
 
car88631.0%
 
medical85401.0%
 
moving54140.6%
 
vacation47360.5%
 
Other values (4)70520.8%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length18
Median length18
Mean length15.0333961
Min length3

State
Categorical

HIGH CARDINALITY

Distinct51
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.8 MiB
CA
129517 
NY
74086 
TX
71138 
FL
60935 
IL
 
35476
Other values (46)
516227 
ValueCountFrequency (%) 
CA12951714.6%
 
NY740868.3%
 
TX711388.0%
 
FL609356.9%
 
IL354764.0%
 
NJ332563.7%
 
PA313933.5%
 
OH296313.3%
 
GA290853.3%
 
VA262553.0%
 
Other values (41)36660741.3%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length2
Median length2
Mean length2
Min length2

debt_income_ratio
Real number (ℝ≥0)

SKEWED

Distinct4086
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.15703874
Minimum0
Maximum9999
Zeros451
Zeros (%)0.1%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile5.2
Q111.91
median17.65
Q323.95
95-th percentile32.72
Maximum9999
Range9999
Interquartile range (IQR)12.04

Descriptive statistics

Standard deviation17.19062569
Coefficient of variation (CV)0.9467747431
Kurtosis256126.8629
Mean18.15703874
Median Absolute Deviation (MAD)6
Skewness441.4867751
Sum16112174.88
Variance295.5176115
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
19.26840.1%
 
14.46740.1%
 
186610.1%
 
13.26380.1%
 
16.86320.1%
 
15.66260.1%
 
20.45980.1%
 
125960.1%
 
21.65940.1%
 
245340.1%
 
Other values (4076)88114299.3%
 
ValueCountFrequency (%) 
04510.1%
 
0.0110< 0.1%
 
0.0212< 0.1%
 
0.038< 0.1%
 
0.046< 0.1%
 
ValueCountFrequency (%) 
99992< 0.1%
 
1092.521< 0.1%
 
672.521< 0.1%
 
380.531< 0.1%
 
137.41< 0.1%
 

delinq_2yrs
Real number (ℝ≥0)

ZEROS

Distinct29
Distinct (%)< 0.1%
Missing29
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.3144418775
Minimum0
Maximum39
Zeros716961
Zeros (%)80.8%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile2
Maximum39
Range39
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.8622438402
Coefficient of variation (CV)2.742140605
Kurtosis57.30908145
Mean0.3144418775
Median Absolute Deviation (MAD)0
Skewness5.473795937
Sum279020
Variance0.74346444
MonotocityNot monotonic
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%) 
071696180.8%
 
111322412.8%
 
2335513.8%
 
3119771.3%
 
453270.6%
 
527110.3%
 
614710.2%
 
77840.1%
 
84610.1%
 
9284< 0.1%
 
Other values (19)5990.1%
 
ValueCountFrequency (%) 
071696180.8%
 
111322412.8%
 
2335513.8%
 
3119771.3%
 
453270.6%
 
ValueCountFrequency (%) 
391< 0.1%
 
301< 0.1%
 
291< 0.1%
 
271< 0.1%
 
262< 0.1%
 

inq_last_6mths
Real number (ℝ≥0)

ZEROS

Distinct28
Distinct (%)< 0.1%
Missing29
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.6946233166
Minimum0
Maximum33
Zeros497905
Zeros (%)56.1%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile3
Maximum33
Range33
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.998447685
Coefficient of variation (CV)1.437394428
Kurtosis11.92510347
Mean0.6946233166
Median Absolute Deviation (MAD)0
Skewness2.108410998
Sum616374
Variance0.9968977796
MonotocityNot monotonic
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%) 
049790556.1%
 
124149427.2%
 
29411710.6%
 
3373984.2%
 
4107581.2%
 
539850.4%
 
612310.1%
 
7195< 0.1%
 
8122< 0.1%
 
950< 0.1%
 
Other values (18)95< 0.1%
 
(Missing)29< 0.1%
 
ValueCountFrequency (%) 
049790556.1%
 
124149427.2%
 
29411710.6%
 
3373984.2%
 
4107581.2%
 
ValueCountFrequency (%) 
331< 0.1%
 
321< 0.1%
 
311< 0.1%
 
281< 0.1%
 
271< 0.1%
 

mths_since_last_delinq
Real number (ℝ≥0)

MISSING

Distinct155
Distinct (%)< 0.1%
Missing454312
Missing (%)51.2%
Infinite0
Infinite (%)0.0%
Mean34.06379844
Minimum0
Maximum188
Zeros1723
Zeros (%)0.2%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile5
Q115
median31
Q350
95-th percentile74
Maximum188
Range188
Interquartile range (IQR)35

Descriptive statistics

Standard deviation21.88494023
Coefficient of variation (CV)0.6424691675
Kurtosis-0.767314425
Mean34.06379844
Median Absolute Deviation (MAD)17
Skewness0.4555195831
Sum14751907
Variance478.9506087
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
985911.0%
 
684701.0%
 
1283680.9%
 
883350.9%
 
1383180.9%
 
782740.9%
 
1082150.9%
 
1480630.9%
 
1580070.9%
 
1178450.9%
 
Other values (145)35058139.5%
 
(Missing)45431251.2%
 
ValueCountFrequency (%) 
017230.2%
 
132870.4%
 
239380.4%
 
349380.6%
 
459590.7%
 
ValueCountFrequency (%) 
1881< 0.1%
 
1801< 0.1%
 
1761< 0.1%
 
1711< 0.1%
 
1703< 0.1%
 

mths_since_last_record
Real number (ℝ≥0)

MISSING

Distinct123
Distinct (%)0.1%
Missing750326
Missing (%)84.6%
Infinite0
Infinite (%)0.0%
Mean70.11790329
Minimum0
Maximum129
Zeros1283
Zeros (%)0.1%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile21
Q151
median70
Q392
95-th percentile115
Maximum129
Range129
Interquartile range (IQR)41

Descriptive statistics

Standard deviation28.12791357
Coefficient of variation (CV)0.4011516638
Kurtosis-0.5852228553
Mean70.11790329
Median Absolute Deviation (MAD)20
Skewness-0.1985676223
Sum9609869
Variance791.1795216
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
6119640.2%
 
6219190.2%
 
6719170.2%
 
7119170.2%
 
6919140.2%
 
6419090.2%
 
6518960.2%
 
6618950.2%
 
6318900.2%
 
7018840.2%
 
Other values (113)11794813.3%
 
(Missing)75032684.6%
 
ValueCountFrequency (%) 
012830.1%
 
171< 0.1%
 
263< 0.1%
 
3114< 0.1%
 
4141< 0.1%
 
ValueCountFrequency (%) 
1291< 0.1%
 
1212< 0.1%
 
1209< 0.1%
 
1199250.1%
 
11814950.2%
 

numb_credit
Real number (ℝ≥0)

Distinct77
Distinct (%)< 0.1%
Missing29
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean11.54846904
Minimum0
Maximum90
Zeros7
Zeros (%)< 0.1%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile5
Q18
median11
Q314
95-th percentile21
Maximum90
Range90
Interquartile range (IQR)6

Descriptive statistics

Standard deviation5.317313125
Coefficient of variation (CV)0.4604344617
Kurtosis3.103994403
Mean11.54846904
Median Absolute Deviation (MAD)3
Skewness1.249380264
Sum10247534
Variance28.27381886
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
9802859.0%
 
10783218.8%
 
8765788.6%
 
11722658.1%
 
7678967.7%
 
12646907.3%
 
13566426.4%
 
6559546.3%
 
14478145.4%
 
15397784.5%
 
Other values (67)24712727.8%
 
ValueCountFrequency (%) 
07< 0.1%
 
1232< 0.1%
 
227760.3%
 
396191.1%
 
4233672.6%
 
ValueCountFrequency (%) 
901< 0.1%
 
841< 0.1%
 
821< 0.1%
 
791< 0.1%
 
762< 0.1%
 

pub_rec
Real number (ℝ≥0)

ZEROS

Distinct32
Distinct (%)< 0.1%
Missing29
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.1953073759
Minimum0
Maximum86
Zeros751572
Zeros (%)84.7%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile1
Maximum86
Range86
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.5820906693
Coefficient of variation (CV)2.980382418
Kurtosis993.1990083
Mean0.1953073759
Median Absolute Deviation (MAD)0
Skewness13.26194117
Sum173306
Variance0.3388295472
MonotocityNot monotonic
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%) 
075157284.7%
 
111326612.8%
 
2148541.7%
 
344870.5%
 
415640.2%
 
57570.1%
 
6385< 0.1%
 
7170< 0.1%
 
8113< 0.1%
 
950< 0.1%
 
Other values (22)132< 0.1%
 
ValueCountFrequency (%) 
075157284.7%
 
111326612.8%
 
2148541.7%
 
344870.5%
 
415640.2%
 
ValueCountFrequency (%) 
861< 0.1%
 
631< 0.1%
 
541< 0.1%
 
492< 0.1%
 
401< 0.1%
 

total revol_bal
Real number (ℝ≥0)

Distinct73740
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16920.78753
Minimum0
Maximum2904836
Zeros3402
Zeros (%)0.4%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile2031
Q16443
median11875
Q320829
95-th percentile43897
Maximum2904836
Range2904836
Interquartile range (IQR)14386

Descriptive statistics

Standard deviation22426.7919
Coefficient of variation (CV)1.325398824
Kurtosis985.8907789
Mean16920.78753
Median Absolute Deviation (MAD)6444
Skewness15.94930161
Sum1.501515152e+10
Variance502960994.7
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
034020.4%
 
523574< 0.1%
 
546672< 0.1%
 
447968< 0.1%
 
696967< 0.1%
 
622367< 0.1%
 
869667< 0.1%
 
584966< 0.1%
 
585366< 0.1%
 
807366< 0.1%
 
Other values (73730)88336499.5%
 
ValueCountFrequency (%) 
034020.4%
 
143< 0.1%
 
245< 0.1%
 
347< 0.1%
 
438< 0.1%
 
ValueCountFrequency (%) 
29048361< 0.1%
 
25689951< 0.1%
 
25607031< 0.1%
 
17467161< 0.1%
 
17432661< 0.1%
 

total_credits
Real number (ℝ≥0)

Distinct135
Distinct (%)< 0.1%
Missing29
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean25.26802615
Minimum1
Maximum169
Zeros0
Zeros (%)0.0%
Memory size6.8 MiB

Quantile statistics

Minimum1
5-th percentile9
Q117
median24
Q332
95-th percentile47
Maximum169
Range168
Interquartile range (IQR)15

Descriptive statistics

Standard deviation11.84056106
Coefficient of variation (CV)0.4685985757
Kurtosis1.377589349
Mean25.26802615
Median Absolute Deviation (MAD)8
Skewness0.8925390335
Sum22421583
Variance140.1988863
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
22322593.6%
 
20321183.6%
 
21320093.6%
 
19315743.6%
 
23313153.5%
 
18311083.5%
 
24310393.5%
 
17307683.5%
 
25297213.3%
 
16291263.3%
 
Other values (125)57631364.9%
 
ValueCountFrequency (%) 
121< 0.1%
 
262< 0.1%
 
34720.1%
 
428730.3%
 
546450.5%
 
ValueCountFrequency (%) 
1691< 0.1%
 
1621< 0.1%
 
1561< 0.1%
 
1511< 0.1%
 
1501< 0.1%
 
Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.8 MiB
f
456848 
w
430531 
ValueCountFrequency (%) 
f45684851.5%
 
w43053148.5%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length1
Median length1
Mean length1
Min length1

total_rec_int
Real number (ℝ≥0)

ZEROS

Distinct324635
Distinct (%)36.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1754.804327
Minimum0
Maximum24205.62
Zeros18214
Zeros (%)2.1%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile80.08
Q1441.46
median1073.28
Q32238.265
95-th percentile5891.48
Maximum24205.62
Range24205.62
Interquartile range (IQR)1796.805

Descriptive statistics

Standard deviation2095.356099
Coefficient of variation (CV)1.194068232
Kurtosis11.5435983
Mean1754.804327
Median Absolute Deviation (MAD)758.87
Skewness2.826099789
Sum1557176509
Variance4390517.183
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0182142.1%
 
82.76138< 0.1%
 
174.9125< 0.1%
 
71.33124< 0.1%
 
283.29119< 0.1%
 
41.37113< 0.1%
 
130.12112< 0.1%
 
194.92108< 0.1%
 
451.32108< 0.1%
 
258.02108< 0.1%
 
Other values (324625)86811097.8%
 
ValueCountFrequency (%) 
0182142.1%
 
0.0111< 0.1%
 
0.391< 0.1%
 
0.561< 0.1%
 
0.591< 0.1%
 
ValueCountFrequency (%) 
24205.621< 0.1%
 
23450.381< 0.1%
 
23172.311< 0.1%
 
23171.651< 0.1%
 
23062.451< 0.1%
 

total_rec_late_fee
Real number (ℝ≥0)

ZEROS

Distinct6106
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.3966917913
Minimum0
Maximum358.68
Zeros874862
Zeros (%)98.6%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum358.68
Range358.68
Interquartile range (IQR)0

Descriptive statistics

Standard deviation4.08782534
Coefficient of variation (CV)10.30478933
Kurtosis515.7241654
Mean0.3966917913
Median Absolute Deviation (MAD)0
Skewness17.4040854
Sum352015.9651
Variance16.71031601
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
087486298.6%
 
1528450.3%
 
30339< 0.1%
 
4558< 0.1%
 
6018< 0.1%
 
17.4816< 0.1%
 
16.3716< 0.1%
 
16.8416< 0.1%
 
18.8715< 0.1%
 
16.0614< 0.1%
 
Other values (6096)91801.0%
 
ValueCountFrequency (%) 
087486298.6%
 
0.016< 0.1%
 
0.0607997511< 0.1%
 
0.0737871041< 0.1%
 
0.0818376851< 0.1%
 
ValueCountFrequency (%) 
358.681< 0.1%
 
294.681< 0.1%
 
286.74756571< 0.1%
 
268.551< 0.1%
 
252.81< 0.1%
 

recoveries
Real number (ℝ≥0)

ZEROS

Distinct23055
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean45.91924337
Minimum0
Maximum33520.27
Zeros862702
Zeros (%)97.2%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum33520.27
Range33520.27
Interquartile range (IQR)0

Descriptive statistics

Standard deviation409.6938736
Coefficient of variation (CV)8.922051923
Kurtosis617.2114172
Mean45.91924337
Median Absolute Deviation (MAD)0
Skewness18.06183892
Sum40747772.26
Variance167849.0701
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
086270297.2%
 
20010< 0.1%
 
14.289< 0.1%
 
11.79< 0.1%
 
109< 0.1%
 
1008< 0.1%
 
16.58< 0.1%
 
8008< 0.1%
 
10.48< 0.1%
 
16.88< 0.1%
 
Other values (23045)246002.8%
 
ValueCountFrequency (%) 
086270297.2%
 
0.251< 0.1%
 
2.341< 0.1%
 
3.61< 0.1%
 
4.41< 0.1%
 
ValueCountFrequency (%) 
33520.271< 0.1%
 
31900.521< 0.1%
 
29623.351< 0.1%
 
29282.071< 0.1%
 
277501< 0.1%
 

collection_recovery_fee
Real number (ℝ≥0)

SKEWED
ZEROS

Distinct20549
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.88075738
Minimum0
Maximum7002.19
Zeros863872
Zeros (%)97.4%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum7002.19
Range7002.19
Interquartile range (IQR)0

Descriptive statistics

Standard deviation63.12528092
Coefficient of variation (CV)12.93350109
Kurtosis1684.165359
Mean4.88075738
Median Absolute Deviation (MAD)0
Skewness29.65569253
Sum4331081.603
Variance3984.801091
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
086387297.4%
 
218< 0.1%
 
1.813< 0.1%
 
1.212< 0.1%
 
1.8812< 0.1%
 
1.5512< 0.1%
 
4.5211< 0.1%
 
0.811< 0.1%
 
3.9311< 0.1%
 
1.611< 0.1%
 
Other values (20539)233962.6%
 
ValueCountFrequency (%) 
086387297.4%
 
0.0361< 0.1%
 
0.0451< 0.1%
 
0.0631< 0.1%
 
0.0710999971< 0.1%
 
ValueCountFrequency (%) 
7002.191< 0.1%
 
6972.591< 0.1%
 
6543.041< 0.1%
 
5774.81< 0.1%
 
5694.09361< 0.1%
 

collections_12_mths_ex_med
Real number (ℝ≥0)

ZEROS

Distinct12
Distinct (%)< 0.1%
Missing145
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.01437952107
Minimum0
Maximum20
Zeros875553
Zeros (%)98.7%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum20
Range20
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.1341907576
Coefficient of variation (CV)9.332074196
Kurtosis1097.854795
Mean0.01437952107
Median Absolute Deviation (MAD)0
Skewness17.4104002
Sum12758
Variance0.01800715942
MonotocityNot monotonic
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%) 
087555398.7%
 
1108241.2%
 
27320.1%
 
388< 0.1%
 
423< 0.1%
 
57< 0.1%
 
62< 0.1%
 
71< 0.1%
 
201< 0.1%
 
161< 0.1%
 
Other values (2)2< 0.1%
 
(Missing)145< 0.1%
 
ValueCountFrequency (%) 
087555398.7%
 
1108241.2%
 
27320.1%
 
388< 0.1%
 
423< 0.1%
 
ValueCountFrequency (%) 
201< 0.1%
 
161< 0.1%
 
141< 0.1%
 
101< 0.1%
 
71< 0.1%
 

mths_since_last_major_derog
Real number (ℝ≥0)

MISSING

Distinct168
Distinct (%)0.1%
Missing665676
Missing (%)75.0%
Infinite0
Infinite (%)0.0%
Mean44.10483846
Minimum0
Maximum188
Zeros153
Zeros (%)< 0.1%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile9
Q127
median44
Q361
95-th percentile77
Maximum188
Range188
Interquartile range (IQR)34

Descriptive statistics

Standard deviation22.17984069
Coefficient of variation (CV)0.5028890586
Kurtosis-0.03136195505
Mean44.10483846
Median Absolute Deviation (MAD)17
Skewness0.2649316915
Sum9778175
Variance491.9453331
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
4534710.4%
 
4234440.4%
 
4634200.4%
 
4834050.4%
 
4333740.4%
 
3833570.4%
 
4433560.4%
 
4033480.4%
 
3732770.4%
 
4132770.4%
 
Other values (158)18797421.2%
 
(Missing)66567675.0%
 
ValueCountFrequency (%) 
0153< 0.1%
 
15910.1%
 
25990.1%
 
36910.1%
 
410000.1%
 
ValueCountFrequency (%) 
1881< 0.1%
 
1801< 0.1%
 
1761< 0.1%
 
1711< 0.1%
 
1703< 0.1%
 

application_type
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.8 MiB
INDIVIDUAL
886868 
JOINT
 
511
ValueCountFrequency (%) 
INDIVIDUAL88686899.9%
 
JOINT5110.1%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length10
Median length10
Mean length9.997120734
Min length5

verification_status_joint
Categorical

MISSING

Distinct3
Distinct (%)0.6%
Missing886868
Missing (%)99.9%
Memory size6.8 MiB
Not Verified
283 
Verified
167 
Source Verified
61 
ValueCountFrequency (%) 
Not Verified283< 0.1%
 
Verified167< 0.1%
 
Source Verified61< 0.1%
 
(Missing)88686899.9%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length15
Median length3
Mean length3.004636125
Min length3

last_week_pay
Categorical

HIGH CARDINALITY

Distinct98
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.8 MiB
13th week
 
50321
9th week
 
47680
26th week
 
45989
22th week
 
43342
4th week
 
43105
Other values (93)
656942 
ValueCountFrequency (%) 
13th week503215.7%
 
9th week476805.4%
 
26th week459895.2%
 
22th week433424.9%
 
4th week431054.9%
 
35th week401624.5%
 
39th week397674.5%
 
17th week366844.1%
 
31th week353864.0%
 
48th week321893.6%
 
Other values (88)47275453.3%
 
Frequencies of value counts

Unique

Unique5 ?
Unique (%)< 0.1%
Histogram of lengths of the category

Length

Max length10
Median length9
Mean length9.075471698
Min length8

acc_now_delinq
Real number (ℝ≥0)

SKEWED
ZEROS

Distinct8
Distinct (%)< 0.1%
Missing29
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.004991266129
Minimum0
Maximum14
Zeros883236
Zeros (%)99.5%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum14
Range14
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.07762534479
Coefficient of variation (CV)15.5522352
Kurtosis1630.866453
Mean0.004991266129
Median Absolute Deviation (MAD)0
Skewness24.06635681
Sum4429
Variance0.006025694155
MonotocityNot monotonic
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
088323699.5%
 
138660.4%
 
2208< 0.1%
 
328< 0.1%
 
47< 0.1%
 
53< 0.1%
 
61< 0.1%
 
141< 0.1%
 
(Missing)29< 0.1%
 
ValueCountFrequency (%) 
088323699.5%
 
138660.4%
 
2208< 0.1%
 
328< 0.1%
 
47< 0.1%
 
ValueCountFrequency (%) 
141< 0.1%
 
61< 0.1%
 
53< 0.1%
 
47< 0.1%
 
328< 0.1%
 

tot_colle_amt
Real number (ℝ≥0)

MISSING
SKEWED
ZEROS

Distinct10325
Distinct (%)1.3%
Missing70276
Missing (%)7.9%
Infinite0
Infinite (%)0.0%
Mean225.7026103
Minimum0
Maximum9152545
Zeros700946
Zeros (%)79.0%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile635
Maximum9152545
Range9152545
Interquartile range (IQR)0

Descriptive statistics

Standard deviation10311.3672
Coefficient of variation (CV)45.68563554
Kurtosis759611.2129
Mean225.7026103
Median Absolute Deviation (MAD)0
Skewness856.1805436
Sum184422280
Variance106324293.4
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
070094679.0%
 
5017550.2%
 
10013570.2%
 
7510440.1%
 
2007140.1%
 
1507020.1%
 
606930.1%
 
706160.1%
 
805960.1%
 
555360.1%
 
Other values (10315)10814412.2%
 
(Missing)702767.9%
 
ValueCountFrequency (%) 
070094679.0%
 
23< 0.1%
 
32< 0.1%
 
41< 0.1%
 
51< 0.1%
 
ValueCountFrequency (%) 
91525451< 0.1%
 
4966511< 0.1%
 
3807571< 0.1%
 
2963681< 0.1%
 
2627401< 0.1%
 

tot_curr_bal
Real number (ℝ≥0)

MISSING

Distinct327342
Distinct (%)40.1%
Missing70276
Missing (%)7.9%
Infinite0
Infinite (%)0.0%
Mean139458.1893
Minimum0
Maximum8000078
Zeros126
Zeros (%)< 0.1%
Memory size6.8 MiB

Quantile statistics

Minimum0
5-th percentile9173
Q129853
median80559
Q3208205
95-th percentile424658.4
Maximum8000078
Range8000078
Interquartile range (IQR)178352

Descriptive statistics

Standard deviation153749.9669
Coefficient of variation (CV)1.102480734
Kurtosis29.40881116
Mean139458.1893
Median Absolute Deviation (MAD)63211
Skewness2.918174325
Sum1.139517049e+11
Variance2.363905232e+10
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0126< 0.1%
 
3457421< 0.1%
 
2239621< 0.1%
 
2923221< 0.1%
 
2731621< 0.1%
 
1999820< 0.1%
 
1451120< 0.1%
 
2326919< 0.1%
 
553719< 0.1%
 
2693719< 0.1%
 
Other values (327332)81679692.0%
 
(Missing)702767.9%
 
ValueCountFrequency (%) 
0126< 0.1%
 
11< 0.1%
 
25< 0.1%
 
32< 0.1%
 
43< 0.1%
 
ValueCountFrequency (%) 
80000781< 0.1%
 
47725491< 0.1%
 
44473971< 0.1%
 
41277991< 0.1%
 
40264051< 0.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

member_idloan_amnttermsbatch_IDRate_of_intrstgradesub_gradeEmp_designationExperiencehome_ownershipannual_incverification_statuspurposeStatedebt_income_ratiodelinq_2yrsinq_last_6mthsmths_since_last_delinqmths_since_last_recordnumb_creditpub_rectotal revol_baltotal_creditsinitial_list_statustotal_rec_inttotal_rec_late_feerecoveriescollection_recovery_feecollections_12_mths_ex_medmths_since_last_major_derogapplication_typeverification_status_jointlast_week_payacc_now_delinqtot_colle_amttot_curr_bal
0581893361435036 months19.19EE3clerk9 yearsOWN28700.0Source Verifieddebt_consolidationFL33.880.01.050.075.014.01.02251528.0f1173.840.00.00.00.074.0INDIVIDUALNaN26th week0.00.028699.0
170011223480036 monthsBAT158659910.99BB4Human Resources Specialist< 1 yearMORTGAGE65000.0Source Verifiedhome_improvementMD3.640.01.0NaNNaN6.00.0762413.0w83.950.00.00.00.0NaNINDIVIDUALNaN9th week0.00.09974.0
2702556751000036 monthsBAT15865997.26AA4Driver2 yearsOWN45000.0Not Verifieddebt_consolidationOH18.420.00.0NaNNaN5.00.01087719.0w56.470.00.00.00.0NaNINDIVIDUALNaN9th week0.065.038295.0
318939361500036 monthsBAT480802219.72DD5Us office of Personnel Management10+ yearsRENT105000.0Not Verifieddebt_consolidationVA14.970.02.046.0NaN10.00.01371221.0f4858.620.00.00.00.0NaNINDIVIDUALNaN135th week0.00.055564.0
476521061600036 monthsBAT283364210.64BB2LAUSD-HOLLYWOOD HIGH SCHOOL10+ yearsRENT52000.0Verifiedcredit_cardCA20.160.00.0NaNNaN11.00.03583527.0w2296.410.00.00.00.0NaNINDIVIDUALNaN96th week0.00.047159.0
5102472681500036 monthsBAT25755498.90AA5Design Consultant2 yearsMORTGAGE120000.0Not Verifieddebt_consolidationIN12.300.00.056.0NaN18.00.01904030.0f1957.240.00.00.00.0NaNINDIVIDUALNaN113th week0.00.0350619.0
68089625500036 months7.90AA4TOYOTA OF NORTH HOLLYWOOD5 yearsRENT75000.0Source Verifieddebt_consolidationCA5.700.00.0NaN105.013.02.01327223.0f578.360.00.00.00.0NaNINDIVIDUALNaN117th week0.01023.013272.0
723043116600036 monthsNaN9.17BB1Banker8 yearsMORTGAGE54000.0Not Verifiedcredit_cardAL11.630.01.046.0NaN13.00.0348449.0f637.510.00.00.00.054.0INDIVIDUALNaN78th week0.00.0272579.0
845900933600036 monthsBAT413615213.99CC4LVN7 yearsMORTGAGE92000.0Not Verifiedhome_improvementCA30.850.00.077.0NaN16.00.04756727.0w621.720.00.00.00.0NaNINDIVIDUALNaN44th week0.00.0281521.0
9412725073455060 monthsBAT469457217.14DD4Registered Nurse2 yearsMORTGAGE72000.0Verifieddebt_consolidationKY33.920.00.0NaNNaN12.00.03004030.0w5535.460.00.00.00.0NaNINDIVIDUALNaN52th week0.00.076034.0

Last rows

member_idloan_amnttermsbatch_IDRate_of_intrstgradesub_gradeEmp_designationExperiencehome_ownershipannual_incverification_statuspurposeStatedebt_income_ratiodelinq_2yrsinq_last_6mthsmths_since_last_delinqmths_since_last_recordnumb_creditpub_rectotal revol_baltotal_creditsinitial_list_statustotal_rec_inttotal_rec_late_feerecoveriescollection_recovery_feecollections_12_mths_ex_medmths_since_last_major_derogapplication_typeverification_status_jointlast_week_payacc_now_delinqtot_colle_amttot_curr_bal
887369554373363000036 months6.89AA3Director2 yearsRENT141000.0Verifiedcredit_cardNY4.880.00.0NaNNaN5.00.03103418.0w1091.170.00.00.00.0NaNINDIVIDUALNaN31th week0.00.0137358.0
887370258560201000036 monthsBAT44647910.15BB2Senior Event Services Manager9 yearsMORTGAGE40000.0Not Verifiedcredit_cardFL6.630.01.037.0NaN7.00.0630017.0f1151.250.00.00.00.033.0INDIVIDUALNaN74th week0.00.097785.0
887371103869222225036 monthsBAT35637247.90AA4Engineer5 yearsMORTGAGE86000.0Verifiedcredit_cardLA28.500.02.0NaNNaN14.00.02689744.0f2567.720.00.00.00.0NaNINDIVIDUALNaN113th week0.00.0331709.0
887372707216781080060 months20.99EE5Ccr10+ yearsRENT41000.0Verifieddebt_consolidationOH32.700.03.0NaN30.017.01.0356949.0w163.720.00.00.00.0NaNINDIVIDUALNaN4th week0.00.056129.0
887373703484841430036 months15.41DD1Supervisor10+ yearsRENT52000.0VerifiedotherNY19.301.00.05.0NaN15.00.0968733.0w159.160.00.00.00.0NaNINDIVIDUALNaN4th week0.00.088713.0
887374191451051500036 monthsBAT42172426.49AA2Network administrator1 yearMORTGAGE97250.0Not Verifiedcredit_cardTX12.460.00.077.0NaN12.00.01220124.0w1180.320.00.00.00.077.0INDIVIDUALNaN83th week0.00.0143920.0
887375463047773500060 months25.89GG3Credit Risk Analyst1 yearOWN180000.0Verifieddebt_consolidationNY11.782.02.019.0NaN21.00.05258433.0f6508.410.00.00.00.0NaNINDIVIDUALNaN39th week0.00.0772713.0
8873769037451400060 monthsBAT611718417.51EE4USPS/Nashua L&DC10+ yearsOWN56000.0Verifiedhome_improvementNH16.440.03.054.0103.011.01.01094825.0f3456.240.00.00.00.0NaNINDIVIDUALNaN87th week0.0NaNNaN
887377530324752000036 monthsBAT38407857.26AA4Computer Engineer< 1 yearMORTGAGE100000.0Source Verifiedcredit_cardMD15.000.00.0NaNNaN7.00.03359911.0w766.840.00.00.00.0NaNINDIVIDUALNaN35th week0.00.0291998.0
887378994245270060 monthsNaN7.49AA4Jimmy John's Sandwiches2 yearsOWN12000.0Not Verifieddebt_consolidationFL28.000.00.0NaNNaN7.00.051187.0f326.060.00.00.00.0NaNINDIVIDUALNaN104th week0.0NaNNaN